package henu.javaweb.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.net.URLEncoder;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import henu.javaweb.bean.Student;
import henu.javaweb.dao.StudentDao;
import henu.javaweb.util.WebDbPool;

/**
 * Servlet implementation class AlterStudentServlet
 */
@WebServlet("/AlterStudentServlet")
public class AlterStudentServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public AlterStudentServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		response.getWriter().append("Served at: ").append(request.getContextPath());
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		PrintWriter out=response.getWriter();
		StudentDao studentDao =new StudentDao();
		if(request.getParameter("sno")!=null){
			Student student=studentDao.findBySno(request.getParameter("id"));
			student.setS_birthdate(request.getParameter("birthday").toString());
			student.setS_no(request.getParameter("sno"));
			student.setS_name(request.getParameter("sname"));
			student.setS_nameUsed(request.getParameter("sbefore_name"));
			student.setS_spellname(request.getParameter("pinyin"));
			student.setS_gender(request.getParameter("sex"));
			student.setS_IDCard(request.getParameter("sidcard"));
			student.setS_nativePlace(request.getParameter("snativePlace"));
			student.setS_nation(request.getParameter("snation"));
			student.setS_politicalStatus(request.getParameter("status"));
			student.setS_phone(request.getParameter("phone"));
			student.setS_email(request.getParameter("email"));
			student.setS_faculty(request.getParameter("college"));
			student.setS_major(request.getParameter("major"));
			student.setS_remarks(request.getParameter("remark"));
			int i=studentDao.update(student);
			System.out.println(i);
			String a="";
			if(i==1) {
				a = URLEncoder.encode("修改成功", "UTF-8"); 
				response.sendRedirect("jsp/teacher/addStudent.jsp");
			}
			else{
				a = URLEncoder.encode("修改失败", "UTF-8"); 
			out.print("<script type=\'text/javascript\'>alert(decodeURIComponent('"+a+"'));history.go(-1);</script>");
			}
		}

        
	}

}
